<!DOCTYPE html>
<html lang="en-US">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <title>Get started | Luckysheet Document</title>
    <meta name="generator" content="VuePress 1.7.1">
    
    <meta name="description" content="Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.This site contains official configuration document, API, and tutorial.">
    <meta property="article:modified_time" content="2020-12-17T08:23:07.000Z">
    <meta property="og:title" content="Get started">
    <meta property="og:type" content="article">
    <meta property="og:url" content="https://mengshukeji.github.io/LuckysheetDemo/guide/">
    <meta name="twitter:title" content="Get started">
    <meta name="twitter:url" content="https://mengshukeji.github.io/LuckysheetDemo/guide/">
    <meta name="twitter:card" content="summary_large_image">
    <meta name="twitter:label1" content="Written by">
    
    <link rel="preload" href="/LuckysheetDocs/assets/css/0.styles.48756c9a.css" as="style"><link rel="preload" href="/LuckysheetDocs/assets/js/app.fd749708.js" as="script"><link rel="preload" href="/LuckysheetDocs/assets/js/2.08ae9631.js" as="script"><link rel="preload" href="/LuckysheetDocs/assets/js/12.ba6e3444.js" as="script"><link rel="prefetch" href="/LuckysheetDocs/assets/js/10.5aa5c910.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/11.b5f38301.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/13.facb0d4d.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/14.5329ef33.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/15.b16af5b8.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/16.3ab9af64.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/17.89342c1c.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/18.4117a1ba.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/19.b7bced65.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/20.085877c0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/21.7942a443.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/22.71c06ffc.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/23.7e0bb3f7.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/24.b3632420.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/25.af0769a6.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/26.003d03b5.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/27.d66536ec.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/28.4c5a65e7.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/29.cde76ea7.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/3.5220f451.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/30.431c8d21.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/31.b1bc10b5.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/32.0303e169.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/33.2fdafa57.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/4.17e14ac8.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/5.d496610c.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/6.edd4669e.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/7.9a67dd07.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/8.4431336c.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/9.d6068f70.js">
    <link rel="stylesheet" href="/LuckysheetDocs/assets/css/0.styles.48756c9a.css">
  </head>
  <body>
    <div id="app" data-server-rendered="true"><div class="theme-container"><header class="navbar"><div class="sidebar-button"><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" role="img" viewBox="0 0 448 512" class="icon"><path fill="currentColor" d="M436 124H12c-6.627 0-12-5.373-12-12V80c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12z"></path></svg></div> <a href="/LuckysheetDocs/" class="home-link router-link-active"><img src="/LuckysheetDocs/img/logo.png" alt="Luckysheet Document" class="logo"> <span class="site-name can-hide">Luckysheet Document</span></a> <div class="links"><div class="search-box"><input aria-label="Search" autocomplete="off" spellcheck="false" value=""> <!----></div> <nav class="nav-links can-hide"><div class="nav-item"><a href="/LuckysheetDocs/" class="nav-link">
  Home
</a></div><div class="nav-item"><a href="/LuckysheetDocs/guide/" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  Guide
</a></div><div class="nav-item"><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Demo
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="More" class="dropdown-title"><span class="title">More</span> <span class="arrow down"></span></button> <button type="button" aria-label="More" class="mobile-dropdown-title"><span class="title">More</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/about/" class="nav-link">
  About
</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="Select language" class="dropdown-title"><span class="title">Languages</span> <span class="arrow down"></span></button> <button type="button" aria-label="Select language" class="mobile-dropdown-title"><span class="title">Languages</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/guide/" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  English
</a></li><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/guide/" class="nav-link">
  简体中文
</a></li></ul></div></div> <a href="https://github.com/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer" class="repo-link">
    GitHub
    <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav></div></header> <div class="sidebar-mask"></div> <aside class="sidebar"><nav class="nav-links"><div class="nav-item"><a href="/LuckysheetDocs/" class="nav-link">
  Home
</a></div><div class="nav-item"><a href="/LuckysheetDocs/guide/" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  Guide
</a></div><div class="nav-item"><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Demo
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="More" class="dropdown-title"><span class="title">More</span> <span class="arrow down"></span></button> <button type="button" aria-label="More" class="mobile-dropdown-title"><span class="title">More</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/about/" class="nav-link">
  About
</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="Select language" class="dropdown-title"><span class="title">Languages</span> <span class="arrow down"></span></button> <button type="button" aria-label="Select language" class="mobile-dropdown-title"><span class="title">Languages</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/guide/" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  English
</a></li><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/guide/" class="nav-link">
  简体中文
</a></li></ul></div></div> <a href="https://github.com/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer" class="repo-link">
    GitHub
    <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav>  <ul class="sidebar-links"><li><a href="/LuckysheetDocs/guide/" aria-current="page" class="active sidebar-link">Get started</a><ul class="sidebar-sub-headers"><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/#introduction" class="sidebar-link">Introduction</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/#demo" class="sidebar-link">Demo</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/#online-case" class="sidebar-link">Online Case</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/#features" class="sidebar-link">Features</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/#development-model" class="sidebar-link">Development model</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/#steps-for-usage" class="sidebar-link">Steps for usage</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/#structure" class="sidebar-link">Structure</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/#keyboard-shortcuts" class="sidebar-link">Keyboard shortcuts</a></li><li class="sidebar-sub-header"><a href="/LuckysheetDocs/guide/#guide" class="sidebar-link">Guide</a></li></ul></li><li><a href="/LuckysheetDocs/guide/config.html" class="sidebar-link">Overall configuration</a></li><li><a href="/LuckysheetDocs/guide/sheet.html" class="sidebar-link">Sheet Configuration</a></li><li><a href="/LuckysheetDocs/guide/cell.html" class="sidebar-link">Format attributes</a></li><li><a href="/LuckysheetDocs/guide/operate.html" class="sidebar-link">Table Operation</a></li><li><a href="/LuckysheetDocs/guide/api.html" class="sidebar-link">API</a></li><li><a href="/LuckysheetDocs/guide/resource.html" class="sidebar-link">Tutorials and resources</a></li><li><a href="/LuckysheetDocs/guide/FAQ.html" class="sidebar-link">FAQ</a></li><li><a href="/LuckysheetDocs/guide/contribute.html" class="sidebar-link">Contribution guide</a></li></ul> </aside> <main class="page"> <div class="theme-default-content content__default"><h1 id="get-started"><a href="#get-started" class="header-anchor">#</a> Get started</h1> <h2 id="introduction"><a href="#introduction" class="header-anchor">#</a> Introduction</h2> <p>Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.</p> <h2 id="demo"><a href="#demo" class="header-anchor">#</a> Demo</h2> <p><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer">Online demo<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></p> <p><img src="/LuckysheetDocs/img/LuckysheetDemo.gif" alt="Demo"></p> <h2 id="online-case"><a href="#online-case" class="header-anchor">#</a> Online Case</h2> <ul><li><a href="http://luckysheet.lashuju.com/demo/" target="_blank" rel="noopener noreferrer">Cooperative editing demo<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>(Note: The official Java backend will also be open source after finishing,using OT algorithm. Please do not operate frequently to prevent the server from crashing)</li></ul> <h2 id="features"><a href="#features" class="header-anchor">#</a> Features</h2> <h3 id="🛠️formatting"><a href="#🛠️formatting" class="header-anchor">#</a> 🛠️Formatting</h3> <ul><li><strong>Styling</strong> (Change font style, size, color, or apply effects)</li> <li><strong>Conditional formatting</strong> (highlight interesting cells or ranges of cells, emphasize unusual values, and visualize data by using data bars, color scales, and icon sets that correspond to specific variations in the data)</li> <li><strong>Align or rotate text</strong></li> <li><strong>Support text truncation, overflow, automatic line wrapping</strong></li> <li><strong>Data types</strong> <ul><li><strong>currency, percentages, decimals, dates</strong></li> <li><strong>Custom</strong> (E.g <code>##,###0.00</code> , <code>$1,234.56$##,###0.00_);[Red]($##,###0.00)</code>, <code>_($* ##,###0.00_);_(...($* &quot;-&quot;_);_(@_)</code>, <code>08-05 PM 01:30MM-dd AM/PM hh:mm</code> )</li></ul></li> <li><strong>Cell segmentation style</strong> (Alt+Enter line break, sub,super, in-cell style)</li></ul> <h3 id="🧬cells"><a href="#🧬cells" class="header-anchor">#</a> 🧬Cells</h3> <ul><li><strong>Move cells by drag and dropping</strong> (Operate on selection)</li> <li><strong>Fill handle</strong> (For a series like 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. For the series 2, 4, 6, 8..., type 2 and 4. Support arithmetic sequence, geometric sequence,date, week,chinese numbers)</li> <li><strong>Auto Fill Options</strong> (Fill copy, sequence, only format, no format, day, month, year)</li> <li><strong>Multiple selection</strong> (Hold Ctrl Selecting multiple cells, copy and paste)</li> <li><strong>Find and replace</strong> (Such as a particular number or text string, Support regular expression, whole word, case sensitive)</li> <li><strong>Location</strong> (Cells can be selected according to the data type)</li> <li><strong>Merge cells</strong></li> <li><strong>Data validation</strong>  (Checkbox, drop-down list, datePicker)</li></ul> <h3 id="🖱️row-columns"><a href="#🖱️row-columns" class="header-anchor">#</a> 🖱️Row &amp; columns</h3> <ul><li><strong>Hide, Insert, Delete rows and columns</strong></li> <li><strong>Frozen rows and columns</strong> (First row, first column, Frozen to selection, freeze adjustment lever can be dragged)</li> <li><strong>Split text</strong> (Split text into different columns with the Convert Text to Columns Wizard)</li></ul> <h3 id="🔨operation"><a href="#🔨operation" class="header-anchor">#</a> 🔨Operation</h3> <ul><li><strong>Undo/Redo</strong></li> <li><strong>Copy/Paste/Cut</strong> (Copy from excel to Luckysheet with format, vice versa)</li> <li><strong>Hot key</strong> (The operating experience is consistent with excel, if there are differences or missing, please feedback to us)</li> <li><strong>Format Painter</strong> (Similar to google sheet)</li> <li><strong>Selection by drag and dropping</strong> (Change the parameters of formula and chart through selection)</li></ul> <h3 id="⚙️formulas-functions"><a href="#⚙️formulas-functions" class="header-anchor">#</a> ⚙️Formulas &amp; functions</h3> <ul><li><strong>Built-in formulas</strong> <ul><li>Math (SUMIFS, AVERAGEIFS, SUMIF, SUM, etc.)</li> <li>Text (CONCATENATE, REGEXMATCH, MID)</li> <li>Date (DATEVALUE, DATEDIF, NOW, WEEKDAY, etc.)</li> <li>Financial (PV, FV, IRR, NPV, etc.)</li> <li>Logical (IF, AND, OR, IFERROR, etc.)</li> <li>Lookup (VLOOKUP, HLOOkUP, INDIRECT, OFFSET, etc.)</li> <li>Dynamic Array (Excel2019 new formulas, SORT,FILTER,UNIQUE,RANDARRAY,SEQUENCE)</li></ul></li> <li><strong>Array</strong> (={1,2,3,4,5,6}, Crtl+Shift+Enter)</li> <li><strong>Remote formulas</strong> (DM_TEXT_TFIDF, DM_TEXT_TEXTRANK,DATA_CN_STOCK_CLOSE etc. Need remote interface, can realize complex calculation)</li> <li><strong>Custom</strong>  (Some formula suitable for use in China have been added. AGE_BY_IDCARD, SEX_BY_IDCARD, BIRTHDAY_BY_IDCARD, PROVINCE_BY_IDCARD, CITY_BY_IDCARD, etc. You can define any formula you want)</li></ul> <h3 id="📐tables"><a href="#📐tables" class="header-anchor">#</a> 📐Tables</h3> <ul><li><strong>Filters</strong> (Support color , numerical, date, text filtering)</li> <li><strong>Sort</strong> (Sort multiple fields simultaneously)</li></ul> <h3 id="📈pivot-table"><a href="#📈pivot-table" class="header-anchor">#</a> 📈Pivot table</h3> <ul><li><strong>Arrange fields</strong> (Add fileds to rows, columns, values, area, it is similar to excel)</li> <li><strong>Aggregation</strong>  (Surport Sum,Count,CountA,CountUnique,Average,Max,Min,Median,Product,Stdev,Stdevp,Var,VarP etc.)</li> <li><strong>Filter data</strong> (Add fileds to filters area and analyze the desired data )</li> <li><strong>Drill down</strong> (Double click pivot table cell to drill down for detail data )</li> <li><strong>Create a PivotChart</strong> (Pivot table can create a chart )</li></ul> <h3 id="📊chart"><a href="#📊chart" class="header-anchor">#</a> 📊Chart</h3> <ul><li><strong>Support types</strong> (Line, Column, Area, Bar, Pie, comming soon Scatter, Radar, Gauge, Funnel etc.)</li> <li><strong>Chart Plugins</strong>  (Link to another project <a href="https://github.com/mengshukeji/chartMix" target="_blank" rel="noopener noreferrer">ChartMix<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>(MIT): ECharts is currently supported,Highcharts, Ali G2, amCharts, googleChart, chart.js are being developed gradually)</li> <li><strong>Sparklines</strong> (Support by formula : Line, Pie, Box, Pie etc.)</li></ul> <h3 id="✍️share"><a href="#✍️share" class="header-anchor">#</a> ✍️Share</h3> <ul><li><strong>Comments</strong> (Add, delete, update)</li> <li><strong>Collaborate</strong> (Simultaneous editing by multiple users)</li></ul> <h3 id="📚insert-object"><a href="#📚insert-object" class="header-anchor">#</a> 📚Insert object</h3> <ul><li><strong>Insert picture</strong> (JPG,PNG,SVG and so on)</li></ul> <h3 id="⚡luckysheet"><a href="#⚡luckysheet" class="header-anchor">#</a> ⚡Luckysheet</h3> <ul><li><strong>Matrix operation</strong> (Operate selection through the right-click menu: transpose, rotate, numerical calculation)</li> <li><strong>Screenshot</strong> (Take a screenshot with selection)</li> <li><strong>Copy to</strong> (In the right-click menu, copy selection to json, array etc.)</li> <li><strong>EXCEL import/export</strong> (Specially adapted to Luckysheet, export is under development)</li></ul> <h3 id="⏱️coming-soon"><a href="#⏱️coming-soon" class="header-anchor">#</a> ⏱️Coming soon</h3> <ul><li><strong>Print</strong> (Like excel print option, save to PDF)</li> <li><strong>Tree menu</strong> (Just like the outline (group)  function of excel)</li> <li><strong>Table new Features</strong> (filter, slicer)</li> <li><strong>CSV,TXT import/export</strong> (Specially adapted to Luckysheet)</li> <li><strong>Insert Shapes</strong> (<a href="https://github.com/mengshukeji/Pentool" target="_blank" rel="noopener noreferrer">Pen tool<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a> Shapes)</li> <li><strong>Documentation</strong> (Improve documentation and API)</li> <li><strong>More...</strong> (Please advise us)</li></ul> <h2 id="development-model"><a href="#development-model" class="header-anchor">#</a> Development model</h2> <h3 id="requirements"><a href="#requirements" class="header-anchor">#</a> Requirements</h3> <p><a href="https://nodejs.org/en/" target="_blank" rel="noopener noreferrer">Node.js<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a> Version &gt;= 6</p> <h3 id="installation"><a href="#installation" class="header-anchor">#</a> Installation</h3> <div class="language-shell extra-class"><pre class="language-shell"><code><span class="token function">npm</span> <span class="token function">install</span>
<span class="token function">npm</span> <span class="token function">install</span> gulp -g
</code></pre></div><h3 id="development"><a href="#development" class="header-anchor">#</a> Development</h3> <div class="language-shell extra-class"><pre class="language-shell"><code><span class="token function">npm</span> run dev
</code></pre></div><h3 id="package"><a href="#package" class="header-anchor">#</a> Package</h3> <div class="language-shell extra-class"><pre class="language-shell"><code><span class="token function">npm</span> run build
</code></pre></div><h2 id="steps-for-usage"><a href="#steps-for-usage" class="header-anchor">#</a> Steps for usage</h2> <h3 id="first-step"><a href="#first-step" class="header-anchor">#</a> First step</h3> <p>There are two ways to introduce dependencies</p> <h4 id="cdn"><a href="#cdn" class="header-anchor">#</a> CDN</h4> <div class="language-html extra-class"><pre class="language-html"><code><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>https://cdn.jsdelivr.net/npm/luckysheet/dist/plugins/css/pluginsCss.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>https://cdn.jsdelivr.net/npm/luckysheet/dist/plugins/plugins.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>https://cdn.jsdelivr.net/npm/luckysheet/dist/css/luckysheet.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>https://cdn.jsdelivr.net/npm/luckysheet/dist/assets/iconfont/iconfont.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>script</span> <span class="token attr-name">src</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">&quot;</span>https://cdn.jsdelivr.net/npm/luckysheet/dist/plugins/js/plugin.js<span class="token punctuation">&quot;</span></span><span class="token punctuation">&gt;</span></span><span class="token script"></span><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>script</span><span class="token punctuation">&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>script</span> <span class="token attr-name">src</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">&quot;</span>https://cdn.jsdelivr.net/npm/luckysheet/dist/luckysheet.umd.js<span class="token punctuation">&quot;</span></span><span class="token punctuation">&gt;</span></span><span class="token script"></span><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>script</span><span class="token punctuation">&gt;</span></span>
</code></pre></div><p>Note that <code>https://cdn.jsdelivr.net/npm/luckysheet/dist/luckysheet.umd.js</code> will pull the latest luckysheet code. If you want to specify the luckysheet version, please add the version number after the luckysheet , Such as: <code>https://cdn.jsdelivr.net/npm/luckysheet@2.0.0/dist/luckysheet.umd.js</code></p> <p>If it is not convenient to access jsdelivr.net, you can also import it locally</p> <h4 id="import-locally"><a href="#import-locally" class="header-anchor">#</a> Import locally</h4> <p>After <code>npm run build</code>, all files in the <code>dist</code> folder are copied to the project directory</p> <div class="language-html extra-class"><pre class="language-html"><code><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>./plugins/css/pluginsCss.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>./plugins/plugins.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>./css/luckysheet.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>link</span> <span class="token attr-name">rel</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>stylesheet<span class="token punctuation">'</span></span> <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">'</span>./assets/iconfont/iconfont.css<span class="token punctuation">'</span></span> <span class="token punctuation">/&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>script</span> <span class="token attr-name">src</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">&quot;</span>./plugins/js/plugin.js<span class="token punctuation">&quot;</span></span><span class="token punctuation">&gt;</span></span><span class="token script"></span><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>script</span><span class="token punctuation">&gt;</span></span>
<span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>script</span> <span class="token attr-name">src</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">&quot;</span>./luckysheet.umd.js<span class="token punctuation">&quot;</span></span><span class="token punctuation">&gt;</span></span><span class="token script"></span><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>script</span><span class="token punctuation">&gt;</span></span>
</code></pre></div><h3 id="second-step"><a href="#second-step" class="header-anchor">#</a> Second step</h3> <p>Specify a table container</p> <div class="language-html extra-class"><pre class="language-html"><code><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;</span>div</span> <span class="token attr-name">id</span><span class="token attr-value"><span class="token punctuation attr-equals">=</span><span class="token punctuation">&quot;</span>luckysheet<span class="token punctuation">&quot;</span></span><span class="token style-attr language-css"><span class="token attr-name"> <span class="token attr-name">style</span></span><span class="token punctuation">=&quot;</span><span class="token attr-value"><span class="token property">margin</span><span class="token punctuation">:</span>0px<span class="token punctuation">;</span><span class="token property">padding</span><span class="token punctuation">:</span>0px<span class="token punctuation">;</span><span class="token property">position</span><span class="token punctuation">:</span>absolute<span class="token punctuation">;</span><span class="token property">width</span><span class="token punctuation">:</span>100%<span class="token punctuation">;</span><span class="token property">height</span><span class="token punctuation">:</span>100%<span class="token punctuation">;</span><span class="token property">left</span><span class="token punctuation">:</span> 0px<span class="token punctuation">;</span><span class="token property">top</span><span class="token punctuation">:</span> 0px<span class="token punctuation">;</span></span><span class="token punctuation">&quot;</span></span><span class="token punctuation">&gt;</span></span><span class="token tag"><span class="token tag"><span class="token punctuation">&lt;/</span>div</span><span class="token punctuation">&gt;</span></span>
</code></pre></div><h3 id="third-step"><a href="#third-step" class="header-anchor">#</a> Third step</h3> <p>Create a table</p> <div class="language-javascript extra-class"><pre class="language-javascript"><code><span class="token operator">&lt;</span>script<span class="token operator">&gt;</span>
    <span class="token function">$</span><span class="token punctuation">(</span><span class="token keyword">function</span> <span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span>
        <span class="token comment">//Configuration item</span>
        <span class="token keyword">var</span> options <span class="token operator">=</span> <span class="token punctuation">{</span>
            container<span class="token operator">:</span> <span class="token string">'luckysheet'</span> <span class="token comment">//luckysheet is the container id</span>
        <span class="token punctuation">}</span>
        luckysheet<span class="token punctuation">.</span><span class="token function">create</span><span class="token punctuation">(</span>options<span class="token punctuation">)</span>
    <span class="token punctuation">}</span><span class="token punctuation">)</span>
<span class="token operator">&lt;</span><span class="token operator">/</span>script<span class="token operator">&gt;</span>
</code></pre></div><h2 id="structure"><a href="#structure" class="header-anchor">#</a> Structure</h2> <h3 id="format"><a href="#format" class="header-anchor">#</a> Format</h3> <p>The data format of a complete Luckysheet table file is: luckysheetfile, a table file contains several sheet files, corresponding to excel sheet0, sheet1, etc.</p> <p>An example of a Luckysheet file is as follows, the table contains 3 sheets:<code>luckysheetfile = [{sheet1 settings}, {sheet2 settings}, {sheet3 settings}]</code>
Equivalent to 3 sheets of excel</p> <p><img src="/LuckysheetDocs/img/excel.png" alt="excel sheet"></p> <p>An example of a sheet in the file is as follows:</p> <div class="language-javascript extra-class"><pre class="language-javascript"><code>luckysheetfile<span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">]</span> <span class="token operator">=</span> 
<span class="token punctuation">{</span>
	<span class="token string">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Cell&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet name</span>
	<span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet color</span>
	<span class="token string">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Table row height, column width, merged cells, borders, hidden rows and other settings</span>
	<span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet index</span>
	<span class="token string">&quot;chart&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Chart configuration</span>
	<span class="token string">&quot;status&quot;</span><span class="token operator">:</span> <span class="token string">&quot;1&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Activation status</span>
	<span class="token string">&quot;order&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span><span class="token punctuation">,</span> <span class="token comment">//The order of the worksheet</span>
	<span class="token string">&quot;hide&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span><span class="token comment">//whether to hide</span>
	<span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token number">18</span><span class="token punctuation">,</span> <span class="token comment">//Number of columns</span>
	<span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token number">36</span><span class="token punctuation">,</span> <span class="token comment">//number of rows</span>
	<span class="token string">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Original cell data set</span>
	<span class="token string">&quot;visibledatarow&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//The position of all rows</span>
	<span class="token string">&quot;visibledatacolumn&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//The position of all columns</span>
	<span class="token string">&quot;ch_width&quot;</span><span class="token operator">:</span> <span class="token number">2322</span><span class="token punctuation">,</span> <span class="token comment">//The width of the worksheet area</span>
	<span class="token string">&quot;rh_height&quot;</span><span class="token operator">:</span> <span class="token number">949</span><span class="token punctuation">,</span> <span class="token comment">//The height of the worksheet area</span>
	<span class="token string">&quot;scrollLeft&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//Left and right scroll bar position</span>
	<span class="token string">&quot;scrollTop&quot;</span><span class="token operator">:</span> <span class="token number">315</span><span class="token punctuation">,</span> <span class="token comment">//Up and down scroll bar position</span>
	<span class="token string">&quot;luckysheet_select_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//selected area</span>
	<span class="token string">&quot;luckysheet_conditionformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//Conditional format</span>
	<span class="token string">&quot;calcChain&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span><span class="token comment">//Formula chain</span>
	<span class="token string">&quot;isPivotTable&quot;</span><span class="token operator">:</span><span class="token boolean">false</span><span class="token punctuation">,</span><span class="token comment">//Whether to pivot table</span>
	<span class="token string">&quot;pivotTable&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//Pivot table settings</span>
	<span class="token string">&quot;filter_select&quot;</span><span class="token operator">:</span> <span class="token keyword">null</span><span class="token punctuation">,</span><span class="token comment">//Filter range</span>
	<span class="token string">&quot;filter&quot;</span><span class="token operator">:</span> <span class="token keyword">null</span><span class="token punctuation">,</span><span class="token comment">//Filter configuration</span>
	<span class="token string">&quot;luckysheet_alternateformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Alternate colors</span>
	<span class="token string">&quot;luckysheet_alternateformat_save_modelCustom&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token comment">//Customize alternate colors</span>
<span class="token punctuation">}</span>
</code></pre></div><h3 id="view-method"><a href="#view-method" class="header-anchor">#</a> View method</h3> <p>View in chrome's console
<code>luckysheet.getluckysheetfile()</code>
You can see the complete settings
<code>[{shee1}, {sheet2}, {sheet3}]</code></p> <h2 id="keyboard-shortcuts"><a href="#keyboard-shortcuts" class="header-anchor">#</a> Keyboard shortcuts</h2> <table><thead><tr><th>Keyboard shortcuts</th> <th>Features</th></tr></thead> <tbody><tr><td>CTRL + C</td> <td>Copy cell</td></tr> <tr><td>CTRL + V</td> <td>Paste cell</td></tr> <tr><td>CTRL + X</td> <td>Cut cell</td></tr> <tr><td>CTRL + Z</td> <td>Undo</td></tr> <tr><td>CTRL + Y</td> <td>Redo</td></tr> <tr><td>CTRL + A</td> <td>Select all</td></tr> <tr><td>CTRL + B</td> <td>Bold</td></tr> <tr><td>CTRL + F</td> <td>Find</td></tr> <tr><td>CTRL + H</td> <td>Replace</td></tr> <tr><td>CTRL + I</td> <td>Italic</td></tr> <tr><td>CTRL + UP/DOWN/LEFT/RIGHT</td> <td>Quickly adjust cell marquee</td></tr> <tr><td>SHIFT + UP/DOWN/LEFT/RIGHT</td> <td>Adjust selection area</td></tr> <tr><td>CTRL + Left mouse click</td> <td>Multiple selection cell</td></tr> <tr><td>SHIFT + Left mouse click</td> <td>Adjust selection area</td></tr> <tr><td>UP/DOWN/LEFT/RIGHT</td> <td>Move cell selection box</td></tr> <tr><td>ENTER</td> <td>Edit cell</td></tr> <tr><td>TAB</td> <td>Move cell selection box to the right</td></tr> <tr><td>DELETE</td> <td>Clear cell data</td></tr></tbody></table> <h2 id="guide"><a href="#guide" class="header-anchor">#</a> Guide</h2> <p>If you encounter problems with Luckysheet, follow the steps below to find the answer</p> <ol><li>Use Doge or Google to search for common technical issues</li> <li>For Luckysheet related issues, please view <a href="https://mengshukeji.github.io/LuckysheetDocs/" target="_blank" rel="noopener noreferrer">Luckysheet Official Document<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a>(Note that the function of marking TODO has not yet been implemented)</li> <li>Search <a href="https://mengshukeji.github.io/LuckysheetDocs/guide/FAQ.html" target="_blank" rel="noopener noreferrer">FAQ List<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li> <li>Search <a href="https://groups.google.com/g/luckysheet" target="_blank" rel="noopener noreferrer">Official Forum<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a> to see if anyone has encountered it</li> <li>Try to check or experiment by yourself to find the answer</li> <li>Please try to read the source code to find the answer,</li></ol> <p>If none of the above methods solve your problem, you can consider:</p> <ul><li>Go to <a href="https://groups.google.com/g/luckysheet" target="_blank" rel="noopener noreferrer">Official Forum<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a> to ask questions</li> <li>Go to <a href="https://gitter.im/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer">Gitter<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a> to ask questions</li> <li>If there are obvious problems or the needs cannot be met, please submit <a href="https://github.com/mengshukeji/Luckysheet/issues" target="_blank" rel="noopener noreferrer">issues<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></li></ul> <blockquote><p>Recommended reading <a href="http://www.catb.org/~esr/faqs/smart-questions.html" target="_blank" rel="noopener noreferrer">How To Ask Questions The Smart Way<span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></p></blockquote> <p>At the same time, we strongly recommend you to help us enrich the Luckysheet community</p> <ul><li>If you find a problem with the documentation or code, you can contribute by submitting a PR. All reasonable changes, optimizations, amendments, or document amendments or updates related to submissions will be accepted</li> <li>When you have some experience in using or secondary developing Luckysheet, we encourage you to share it through blog posts</li></ul></div> <footer class="page-edit"><div class="edit-link"><a href="https://github.com/mengshukeji/Luckysheet/edit/master/docs/guide/README.md" target="_blank" rel="noopener noreferrer">Edit this page on GitHub</a> <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></div> <div class="last-updated"><span class="prefix">Last Updated:</span> <span class="time">12/17/2020, 8:23:07 AM</span></div></footer> <div class="page-nav"><p class="inner"><!----> <span class="next"><a href="/LuckysheetDocs/guide/config.html">
        Overall configuration
      </a>
      →
    </span></p></div> </main></div><div class="global-ui"></div></div>
    <script src="/LuckysheetDocs/assets/js/app.fd749708.js" defer></script><script src="/LuckysheetDocs/assets/js/2.08ae9631.js" defer></script><script src="/LuckysheetDocs/assets/js/12.ba6e3444.js" defer></script>
  </body>
</html>
